{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Disclaimer","Annual Growth Rate"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,3,10,8],[11,3,25,8],[21,10,25,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Disclaimer"]
[]
[null,null,null,"This Design Calculation Spreadsheet is provided \"as-is\" without warranty of any kind. The Montana Department of Transportation makes no representations or warranties whatsoever with respect to the accuracy or completeness of this tool and assumes no responsibility for the suitability of this tool for a particular purpose; and MDT will not be liable for any damages incurred as a result of errors in this tool. \n\nBy selecting Accept, you are agreeing to these terms and conditions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"WARNING: \nFor the tool to work properly, please make sure you click on \"Enable Content/Macros\" if the security warning appears."]

{"sheet":"Annual Growth Rate","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Projected Values Based on Annual Growth Rate (AGR)"]
[]
["AGR =",1.6,"%"]
[]
["Present Year","Present Value (PV)",null,"Future Year","Future Value (FV)"]
[2014,1970,null,2019,{"$f":"B6*(B3/100+1)^(D6-A6)","v":2132.7245387952948}]
[2014,1970,null,2039,{"$f":"B7*(B3/100+1)^(D7-A7)","v":2929.6040332388816}]
[2010,4150,null,2030,{"$f":"B8*(B3/100+1)^(D8-A8)","v":5700.6221463597576}]
[2010,1340,null,2030,{"$f":"B9*(B3/100+1)^(D9-A9)","v":1840.6828135233916}]
[2010,1050,null,2011,{"$f":"B10*(B3/100+1)^(D10-A10)","v":1066.8}]
[2010,1600,null,2011,{"$f":"B11*(B3/100+1)^(D11-A11)","v":1625.6}]
[2010,4150,null,2011,{"$f":"B12*(B3/100+1)^(D12-A12)","v":4216.3999999999996}]
[2010,1340,null,2011,{"$f":"B13*(B3/100+1)^(D13-A13)","v":1361.44}]
[2010,1050,null,2031,{"$f":"B14*(B3/100+1)^(D14-A14)","v":1465.4033025871299}]
[2010,1600,null,2031,{"$f":"B15*(B3/100+1)^(D15-A15)","v":2232.9955087041981}]
[2010,4150,null,2031,{"$f":"B16*(B3/100+1)^(D16-A16)","v":5791.8321007015138}]
[2010,1340,null,2031,{"$f":"B17*(B3/100+1)^(D17-A17)","v":1870.133738539766}]
[null,null,null,null,{"$f":"B18*(B3/100+1)^(D18-A18)","v":0}]
[2009,20590,null,2031,{"$f":"B19*(B3/100+1)^(D19-A19)","v":29195.634727879344}]
[null,null,null,null,{"$f":"B20*(B3/100+1)^(D20-A20)","v":0}]
[null,null,null,null,{"$f":"B21*(B3/100+1)^(D21-A21)","v":0}]
[null,null,null,null,{"$f":"B22*(B3/100+1)^(D22-A22)","v":0}]
[null,null,null,null,{"$f":"B23*(B3/100+1)^(D23-A23)","v":0}]
[null,null,null,null,{"$f":"B24*(B3/100+1)^(D24-A24)","v":0}]
[null,null,null,null,{"$f":"B25*(B3/100+1)^(D25-A25)","v":0}]